<?php
    include '../../../controlador/php/conexion/Conexion.php';
    $con = new Conexion();
    
    $oidh = $_REQUEST['hisoid'];
    
        
    $soli = "select hisoid,dnsolicitud,hisfecmod,hisestado,(rtrim(usuario.usu_nombres) + '  ' + usuario.usu_apellidos)as nombres,cast(rtrim(hisobs) as text) as obsh
             from dnhistorial inner join usuario on dnhistorial.usu_oid=usuario.usu_oid
             where hisoid=".$oidh;
    $resul=$con->query($soli);  
    
    while($res = mssql_fetch_array($resul)){
        $listas[] = $res;
    }
    
    print_r(json_encode($listas));
    $con->cerrarConexion();
?>